package com.jin.sys.mapper;

import com.jin.stu.vo.LeaveVo;
import com.jin.sys.domain.Dept;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

/**
 *  Mapper 接口
 *
 * @author Jin
 * @since 2021-04-13
 */
public interface DeptMapper extends BaseMapper<Dept> {

    @Select("SELECT mgr FROM `user` where id= ${id}")
    public Integer findMgrById(Integer id);

    @Select("SELECT deptid FROM `user` where id= ${id}")
    public Integer findDeptIdById(Integer id);

    @Select("SELECT pid FROM `dept` where id= ${id}")
    public Integer getPidByClassesId(Integer id);

}
